Change SQL Maximum Replication Cycles

UMP-365 Synchronization memory use is 2 GB per cycle for the UMP-365 processes. The maximum number of Simultaneous replication cycles in the UMP-365 database must be set to the number of cores -1. The procedure below describes how to set this configuration.

Perform this procedure in the SQL Server Management Studio.

➢

Do the following:

1.

Connect to your database and select SysAdminTenant.

2.

Open Tables and select dbo.ApplicationSetting.

3.

Select Edit Top 200 Rows.

4.

Add a new row type with the new Id: CmdTaskRunnerSvc.MaxDegreeOfParallelism.

5.

Add the maximum number of server cores to -1.